Transform and Load Data 9
The opened page is the Power Query Editor, where the transformation of data takes place before it's loaded.
Stated below are the outlined steps and the GIF:
Filtering out some years at the Power Query Editor:
There was inconsistency in the data. 2004 was missing, so I had to remove all the data before 2005 to report something meaningful.
At the Power Query Editor, select Survey Year and click on the drop-down arrow at the corner.
A dialogue box opens up; click on sort Ascending.
Click to unselect all the years before 2005, click on Load more, and Ok.
6. Replace values:
a. Go to the Replace Values tab at the Power Query Editor
b. In the opened dialog box, put in the value to replace and what to be replaced with, as shown below:
c. Do this for the 6 survey questions.
Find below screenshots of the replaced Survey Questions and 'NULL' replaced with 'zero.'
7. Renamed Columns; Demographics_Question, Demographics_Response, and Survey Question.
Click on the Demographics_Question column
Right-click on the column name and select the rename column.
Repeat it for the other 2 columns.
8. Click on Close and Apply
Click on the link below for a better understanding of working in Power BI Power Query Editor.
https://docs.microsoft.com/en-us/power-query/power-query-quickstart-using-power-bi